package com.sea.finance.mapper;


import com.sea.finance.entity.ExchangeRate;
import com.sea.finance.entity.Inventory;
import org.apache.ibatis.annotations.Param;

import java.util.List;

/**
 *  汇率表接口
 * @author 陈鸿飞
 * <br/>
 */
public interface InventoryMapper {

    /**
     * 查询指定
     * @param inventory
     * @return
     */
    List<Inventory> findByCnd(Inventory inventory);

    /**
     * 新增
     * @param inventory
     * @return
     */
    int insert(Inventory inventory);

    /**
     * 更新本期出库
     * @param inventory
     * @return
     */
    int updateCreditNumberBySkuChannelDate(Inventory inventory);

    /**
     * 更新期末数据
     * @param inventory
     * @return
     */
    int updateEndBySkuChannelDate(Inventory inventory);

    /**
     * 条件查询
     * @param inventory
     * @return
     */
    Inventory findBySkuChannelDate(Inventory inventory);

    /**
     * 获取SKU采购成本
     * @param inventory
     * @return
     */
    List<Inventory> findSkuCost(Inventory inventory);

    int updateBorrowPrice(Inventory inventory);

    /**
     * 查询指定
     * @param inventory
     * @return
     */
    Inventory findBySKuChannel(Inventory inventory);


    Integer update(Inventory inventory);

}